<?php
require_once('../../conf/config.php.inc');
require_once(SYBMAS_LIB_PATH.'/liblogin.php.inc');
require_once(SYBMAS_LAYOUT_PATH.'/layout.php.inc');
require_once(SYBMAS_LIB_PATH.'/libsybmas.php.inc');
require_once(SYBMAS_LAYOUT_PATH.'/menu.php.inc');
require_once('libtablas.php.inc');
verificar_inicio_sesion();
?>


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<link rel="stylesheet" type="text/css" href="<?php echo LAYOUT_URI?>/sybmasstyle.css">
<script src="<?php echo LAYOUT_URI?>/jquery-1.2.1.min.js" type="text/javascript"></script>
<script src="<?php echo LAYOUT_URI?>/menu-collapsed.js" type="text/javascript"></script>
<link rel="stylesheet" type="text/css" href="<?php echo LAYOUT_URI?>/style.css" />
<script src="<?php echo JAVASCRIPT_URI?>/tabs/tabs.js"
	type="text/javascript"></script>
<script type="text/javascript" src="<?php echo JAVASCRIPT_URI?>/commons.js"></script>
<title>.:: Sybmas - Consultar Logins Bloqueados y Desbloqueados</title>
<!--[if lt IE 8]>
   <style type="text/css">
   li a {display:inline-block;}
   li a {display:block;}
   </style>
   <![endif]-->
</head>
<body>
<script src="<?php echo JAVASCRIPT_URI?>/tooltip/wz_tooltip.js"
	type="text/javascript"></script>
<center>
<div id="container">
<div id="header">
<div id=""><?php generar_header();?></div>
</div>
<div id="scene">
<div id="modulos">
<ul id="menu" style="width: 150px;">
<?php generar_menu();?>
</ul>
</div>

<div id="title">Consultar Logins Bloqueados y Desbloqueados</div>
<div id="main">
 
<hr />
<?php 

//$pagina=0;
//$registrosPorPagina=10;

	foreach($_POST as $key=>$value){
		$$key=$value;		
	}
$query="SELECT suid,name, ".
       "CASE status WHEN 2 THEN 'Bloqueado' ".
	   "ELSE 'Desbloqueado' ".
	   "END AS status ".
	   "FROM master..syslogins ";

//$offset=$registrosPorPagina*$pagina;

	if(!empty($sybmas_loginname)){	
		$query.="WHERE name LIKE '%{$sybmas_loginname}%'";		
	}
$query.=" ORDER BY name ASC";	
//echo $query;
?>

<?php
$sybuser_connection=start_default_sybuser_connection();
$result=sybase_query($query,$sybuser_connection);

//$registrosTotales=$result?sybase_num_rows($result):0;
//$paginas=ceil($registrosTotales/$registrosPorPagina);
//$paginaAnterior=$pagina-1;
//$paginaSiguiente=$pagina+1;
?>

<form name="formbloqlogin" method="POST" action=consultarBloqLogin.php>
<table width="80%" border="0">  
  <tr>
    <td width="90">Nombre del Login:</td>
    <td width="40"><input type="text" name="sybmas_loginname"></input></td>
        
  <td></td>      
  
  <td><a href="#" onclick="formbloqlogin.submit();" ><span onmouseover="Tip('Buscar Logins')" onmouseout="UnTip()">		
	<img src="<?php echo IMG_URI?>/page_white_magnify.png"
		 alt="Buscar" width="18" height="18" border="0" alt="Buscar"></span></a> Buscar</td>		   	 		        					     
  </tr>
</table>
</form>

<table width="80%" border="1">
	<tr>
	    <th bgcolor="#8BA7C2">suid</th>	    
		<th bgcolor="#8BA7C2">Nombre del Login Bloqueado</th>		
		<th bgcolor="#8BA7C2">status</th>
		<th bgcolor="#8BA7C2"></th>
    </tr>
    
    <?php
//if($result && $offset<$registrosTotales){
//$i=0;
//sybase_data_seek($result,$offset);
//while($data=sybase_fetch_array($result)){
	//if($i>=$registrosPorPagina){
		//break;
	//}
?>
    
    <?php
	while($data=sybase_fetch_array($result)){						
		?>	
	<tr>
	    <td><?php echo $data['suid']?></td>
	    <td><?php echo $data['name']?></td>
	    <td><?php echo $data['status']?></td>
	    <td width="18">
	    	<a  href="#" 
	    		onclick="showDialog('desbloq.php','suid=<?php echo $data['suid']?>')">
			<span onmouseover="Tip('Bloquear o Desbloquear Login')" onmouseout="UnTip()"><img src="<?php echo IMG_URI?>/lock_edit.png"
			alt="Bloquear Login" width="18" height="18" border="0" alt="Bloquear"></span>
		</a></td>			
	</tr>			    
	<?php
	//$i++;
	}	
	?>	
</table>

<?php
 sybase_free_result($result); 
?> 

<?php
//Cerrando conexiones a la base de datos
sybase_close($sybuser_connection); 
?>
</div>
</div>
<?php generar_footer();?></div>
</center>
</body>
</html>